Suelos Vicfloor®
<-- XPTO: SELECT *, LTRIM(RTRIM(SCL.`name`)) as trimmed_name, SCL.long_name FROM site_products_coatings SC
INNER JOIN site_products_coatings_languages SCL ON SC.id_site_products_coating = SCL.id_site_products_coating
WHERE SCL.id_language = 6 AND SCL.status = 1 AND SC.status = 1 AND (SC.img_name != '' OR SC.img_name_thumb != '') AND SC.id_site_products_coating IN (704,706,718,688,363,380)
GROUP BY SC.id_site_products_coating
ORDER BY SC.order ASC
LIMIT 0, 12 -->
